
# Obsoleted
# A rough method to group counties between shale/non-shale
# Make a list of counties that are impacted by shale gas, flag 1 if the impact is great, 0 if not so. Save as "list.txt"
# If the county's name is on the list, flag = 1 + flag on the list
# If not, flag = 0

BEGIN {
   while ((getline line < "list.txt") > 0) {
     split (line, x)
     county = x[2]
     shale[county] =  x[1]
     flag[county] = x[3]
   }
 }

{
  if (NR == 1) {
    print "Flag Shale", $0
    next
  }
  county = $1
  if (county in shale) {
    print flag[county]+1, shale[county], $0
  } else {
    if ($1 ~ /Texas/){
      print -1, "N/A", $0
      next
    }
    print 0, "N/A", $0
  }
}



